﻿-- =============================================
-- Author:		<Author,XFL>
-- Create date: <Create Date,2011 01 19>
-- Description:	<Description,通过角色ID 查询 角色信息>
-- =============================================
CREATE PROCEDURE [dbo].[proc_NetUser_For_RolesList_GetItem] 
@InRoles varchar(2000)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering ;WITH SELECT statements.
	SET NOCOUNT ON;

	EXEC(
	'SELECT 
	R.[ID] as [ID]
	,ISNULL(R.[RName],'+'''---'''+') as [RName]
	,ISNULL(R.[RNote] ,'+'''---'''+') as [RNote]
	From [App_Roles] R
	Where Id in ('+@InRoles+') order by  RName' 
	)
END
